package me.tuyou.mybatis.test.interfaces.mapper;

import me.tuyou.mybatis.test.interfaces.po.Student;
import me.tuyou.mybatis.test.interfaces.vo.Page;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.session.RowBounds;

import java.util.List;

/**
 * @描述:
 * @创建人: 涂有(tuyou_cd @ keruyun.com)
 * @创建时间: 2019-09-24
 */
public interface StudentMapper {

    int dropTable();

    int createTable();

    int insert(Student student);
    int batchInsert(List<Student> student);

    List<Student> selectAll();

    List<Student> selectNameLike1(@Param("name") String name);
    List<Student> selectNameLike2(@Param("name") String name);
    List<Student> selectNameLike3(@Param("name") String name);
    List<Student> selectNameLike4(@Param("name") String name);

    List<Student> selectByRowBounds(RowBounds rowBounds);

    List<Student> selectByPage(Page page);
}
